USE [AmazonSystem]
GO
Create table AutoaccessoryMisc.AutoAccessoryMiscInfo
(
 AutoAccessoryMisc_InfoID INT IDENTITY(1,1) PRIMARY KEY,
 AutoAccessory_InfoID int not null,
 AutoAccessoryMiscVariationData_InfoID INT NOT NULL,
 ModelYear int ,
 Season nvarchar(50),
 AutoAccessoryMiscColorSpecification_InfoID INT  ,
 Diameter_LengthDimension_InfoID int ,
 ItemPackageQuantity int default 1,
 NumberOfItems int ,
 DisplayLength_LengthDimension_InfoID int ,
 DisplayWeight_WeightDimension_InfoID int ,
 DisplayVolume_VolumeDimension_InfoID int ,
 ItemShape nvarchar(50),
 Material nvarchar(50),
 Size nvarchar(50),
 Viscosity nvarchar(50),
 Volume_VolumeDimension_InfoID int ,
 Voltage int ,
 Wattage int ,
 NumberOfGrooves int ,
 NumberOfHoles int,
 AutoAccessoryMiscPartInterchangeData_InfoID int ,
 ManufacturerWarrantyDescription Nvarchar(50),
 IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
 
)


Create TABLE AutoAccessoryMisc.AutoAccessoryMiscPartInterchangeDataInfo
(
AutoAccessoryMiscPartInterchangeData_InfoID int identity(1,1) primary key,
OEManufacturer nvarchar(50) not null,
PartInterchangeInfo nvarchar(50) not null,
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)

Create table AutoaccessoryMisc.AutoAccessoryMiscColorSpecificationInfo
(
AutoAccessoryMiscColorSpecification_InfoID INT IDENTITY(1,1) PRIMARY KEY,
Color nvarchar(50),
ColorMap nvarchar(50),
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)

Create table AutoaccessoryMisc.AutoAccessoryMiscVariationDataInfo
(
 AutoAccessoryMiscVariationData_InfoID INT IDENTITY(1,1) PRIMARY KEY,
 Parentage NVARCHAR(6) NOT NULL,
 VariationTheme NVARCHAR(9) NOT NULL,
 IsDel bit default 0,
 CreateUser nvarchar(20) default 'PU',
 CreateTime datetime default  getdate(),
 UpdateUser nvarchar(20) default 'FL',
 UpdateTime datetime default getdate()
)

Create table Base.VolumeDimensionInfo
(
VolumeDimension_InfoID int identity(1,1) primary key,
unitOfMeasure nvarchar(12) not null,
Value decimal(18,2) not null,
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)

Create table Base.WeightDimensionInfo
(
WeightDimension_InfoID int identity(1,1) primary key,
unitOfMeasure nvarchar(2) not null,
Value decimal(18,2) not null,
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)

Create table Base.LengthDimensionInfo
(
LengthDimension_InfoID int identity(1,1) primary key,
unitOfMeasure nvarchar(12) not null,
Value decimal(18,2) not null,
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)
 

 
Create table  Base.AmperageDimensionInfo
(
 AmperageDimension_InfoID int identity(1,1) primary key ,
 unitOfMeasure nvarchar(10) not null,
 Value decimal(18,2) not null,
 IsDel bit default 0,
 CreateUser nvarchar(20) default 'PU',
 CreateTime DATETIME DEFAULT GETDATE(),
 UpdateUser nvarchar(20) default 'FL',
 UpdateTime datetime default getdate()
)
